Automatic Generation of SQL/XML Views
نویسندگان
چکیده
This paper proposes an approach to generate XML views of relational data, using SQL/XML. The paper first specify the conditions for a set of correspondence assertions to fully specify the view in terms of the relational schema and, if so, we show that the mappings defined by the view correspondence assertions can be expressed as SQL/XML view definition. This paper focuses on an algorithm that automatically generates the SQL/XML query from the view correspondence assertions.
منابع مشابه
Automatic Generation of SQLX View Definitions from ORA-SS Views
Although XML is the dominant standard for publishing and exchanging data for Internet-based business applications, data is typically stored in relational or object-relational databases. Thus, it is necessary to define XML views over these traditional databases. Unfortunately, it is not easy for users to manually write SQLX queries to define the XML views. This paper describes a method to automa...
متن کاملXML Algebra Optimization
Mapping of XML data into and out of relational database systems, including query processing over such virtual XML views that wrap relational sources, has become a topic of critical importance recently. The Rainbow XML data management system, being developed at WPI, focuses on the processing and optimization of XQuery queries against XML views of that relational data. For this, Rainbow’s query m...
متن کاملUpdating Views Over Recursive XML
We study the problem of updating XML views defined over XML documents. A view update is performed by finding the base updates over the underlying data sources that achieve the desired view update. If such base updates do not exist, the view update is said to be untranslatable and rejected. In SQL, determining whether a view update is translatable is performed using schema level analysis, where ...
متن کاملA Mapping-Driven Approach for SQL/XML View Maintenance
In this work we study the problem of how to incrementally maintain materialized XML views of relational data, based on the semantic mappings that model the relationship between the source and view schemas. The semantic mappings are specified by a set of correspondence assertions, which are simple to understand. The paper focuses on an algorithm to incrementally maintain materialized XML views o...
متن کاملارائه یک ساختار جهت پشتیبانی از پرس‌وجوها در پایگاه داده شیءگرا با فازی سازی برچسب-های XML و با استفاده از میانگین وزنی (OWA) جهت محاسبه درجه تعلق اشیاء
در مسائل مختلف روزمره اطلاعاتی وجود دارند که هرکدام به‌نوعی غیرقطعی می‌باشند. مدیریت کردن این نوع از اطلاعات با استفاده از سیستم‌های پایگاه داده کلاسیک موجب فقدان زیان‌آور معانی داده شده است. بنابراین استفاده از تکنیک‌های پیشرفته مدل‌سازی پایگاه داده ضروری می‌باشد. مدل‌سازی و استفاده از نظریه فازی در پایگاه داده می‌تواند به‌عنوان پایه و اساس پردازش هوشمند اطلاعات مطرح شود. از طرفی XMLدر سال‌ه...
متن کامل